Monthly Payroll Report

[Available only if you select Open Stores]

The Monthly Payroll report shows a daily breakdown of the hours worked during the month and indicates the times when each employee clocked in and clocked out. You can produce the report at any time during the month. However, remember that the hours worked that appear in the report are calculated from the timeclock hours confirmed by the processing of payroll. For the period that has not yet been processed, this report displays scheduled hours. [Show image.][Hide image.]

  1. From the LiveIQ toolbar, click Labor.

  2. Select Reports > Extract/Printed.

  3. Click Monthly Payroll Report.

    A window opens and displays the parameters for the report. This summary identifies the reporting period, which hours are actual hours worked, and the hours identified as night hours. [Show image.][Hide image.]

  4. If the night hours displayed in the summary are not correct, change them in the General section of the Organization Parameters screen.

  5. To generate the report, click Yes.

    LiveIQ prepares the report, exports it as an Excel file, and opens the file to a dashboard page. The dashboard page describes the information in the report and displays several columns for you to enter data. [Show image.][Hide image.]

    In addition to this dashboard page, the Excel file also displays a report description. [Show image.][Hide image.]

  6. [Optional] On the dashboard page, update the data in the Tax ID, Contracted Hours, and CCC columns. The values that you enter in these columns carry forward to the pages for individual employees so make sure that the information that you enter is accurate.

    The CCC column applies only to Spanish organizations.

  7. [Optional] In the Excel file, check the page for each employee and update the data in the Regular Hours column. The value that you enter is used to calculate the number of hours that appears in the Supplementary Hours column of the report. If you do not enter the regular hours worked for an employee, the Supplementary Hours column in the report contains 0.00.